Profitability Index Calculator

Form

Results

Profitability index (PI)

0

1

What is Profitability Index?

The Profitability Index Calculator compares the present value of a project’s expected cash inflows with its initial investment. The result is a ratio: it tells you how many dollars of discounted benefit are represented by each dollar invested. That makes the index useful when several proposed projects are different sizes and available capital is limited.

This calculation begins after the forecasting and discounting work has been done. Enter the present value of future cash flows, not their undiscounted total. The page does not choose a discount rate, judge the reliability of a forecast or account for strategic benefits that are absent from the cash-flow estimate.

2

How to Use This Calculator

  1. Enter the initial investment as a positive amount. Include the project costs that belong in the investment decision and use the same valuation date as the cash-flow present value.
  2. Select its currency, then enter the already-discounted present value of future cash flows. Choose the same currency for both amounts; a ratio made from different currencies is not meaningful.
  3. Choose Calculate. The present value is divided by the initial investment and the result is shown to three decimal places.
  4. Compare the index with 1 and, where projects compete for funds, compare it with the indexes for the other projects. Review net present value and nonfinancial constraints as well.

The form requires an investment above zero because zero would make division undefined. A zero cash-flow present value is permitted and produces an index of zero.

3

Formula Used

Profitability index (PI) = present value of future cash inflows ÷ initial investment. Equivalently, when the same cash flows and outlay are used, PI = 1 + (net present value ÷ initial investment).
4

Variables Explained

ItemMeaningCheck before entering
Initial investmentThe up-front project outlay used as the denominator.Use a positive amount at the chosen valuation date.
PV of future cash flowThe combined present value of expected future project cash inflows.Discount the forecast first; do not enter an undiscounted sum.
CurrencyThe monetary unit shared by both inputs.Select the same currency on both fields.
PIA unit-free benefit-to-cost ratio.Read 1.200 as 1.2 units of present benefit per unit invested.
5

Worked Example

Suppose a project needs an initial investment of $100,000 and its expected future cash inflows have a present value of $120,000. The calculation is PI = $120,000 ÷ $100,000 = 1.200. The related net present value is $20,000, because $120,000 − $100,000 = $20,000.

The example depends on the rate and dates used to obtain the $120,000 present value. If those assumptions change, discount the individual cash flows again before recalculating the index.

6

Why Use This Calculator?

An index above 1 corresponds to a positive net present value under the entered assumptions. An index equal to 1 is the break-even point in present-value terms, while a value below 1 corresponds to a negative net present value. That rule is a screen, not an automatic investment decision.

When capital is rationed, the ratio can help compare benefit per dollar invested. It can still rank projects differently from net present value, especially when projects differ greatly in size or are mutually exclusive. A smaller project can have the higher ratio while adding fewer total dollars of estimated value.

Forecast quality matters more than the extra decimal places in the answer. Review timing, tax effects, working capital, terminal value, inflation treatment and the discount rate. Scenario analysis often tells more than one base-case index.

7

Common Mistakes

    • Entering the simple sum of future receipts instead of their present value.
    • Mixing currencies or valuation dates between numerator and denominator.
    • Leaving out a required initial cost to make the ratio appear stronger.
    • Treating accounting profit as though it were project cash flow.
    • Assuming the highest index always creates the greatest total value.
    • Comparing results produced with inconsistent discount-rate assumptions.
    • Reading a rounded value of 1.000 as proof that the unrounded result is exactly one.
8

Frequently Asked Questions

What does a profitability index of 1.25 mean?

It means the entered present value of benefits is 1.25 times the entered investment. Put another way, the model shows $1.25 of discounted inflow for each $1.00 invested.

Is profitability index the same as return on investment?

No. This index divides discounted future cash inflows by the initial outlay. A return-on-investment measure may use accounting income, undiscounted gain or another definition.

Where do I get the present value input?

Forecast each relevant project cash flow and discount it to the same valuation date using an appropriate rate, then add those present values. This page does not perform that earlier step.

Can I compare projects in different currencies?

Convert their cash flows and investments to one currency under a consistent exchange-rate assumption first. The ratio itself has no currency, but mismatched inputs produce a false comparison.

Why can PI and NPV favor different projects?

PI measures value relative to investment, whereas NPV measures estimated value in money. Project scale can therefore change their rankings.

Does a value above one guarantee a profitable project?

No. It reports what the entered forecast implies. Actual cash flows, timing, costs and the appropriate discount rate can differ from the assumptions.

How many decimals should I use?

Three decimals are useful for screening, but close rankings deserve a review of the underlying forecasts. Precision in the display cannot remove uncertainty from the inputs.

9

Sources & References